ABS
The ABS manipulate step is intended for getting the absolute value of a number. Sometimes you may need to use only positive numbers, and that's where the absolute value comes in handy.
The table below illustrates the examples of this data conversion:
Source Column | Target Column |
---|---|
5 | 5 |
-5 | 5 |
0 | 0 |
1.2 | 1.2 |
-1.2 | 1.2 |
To configure this manipulate step, follow the instructions below:
- In the Admin Navigation tree, select Interfaces > InterfaceName > Tasks > TaskName > Steps.
- On the toolbar, click New >New Manipulate Step.

Creating a New Manipulate Step
- Navigate to the Math section and select ABS.

Math Section
- In the ABS work area, fill in the following fields:

Fields | Description |
---|---|
Name |
Provide a distinctive name for this step. |
Is Active |
Select the check box to engage the scheduler for this step. |
Order of Execution |
Enter the order in which this step should be executed. |
Filter Expression |
Optional. Use this filed to filter data from the source database prior to inserting it into the Schema table. |
Sort Expression |
Optional. Use this field to sort data from the source database prior to inserting it into the Schema table. |
Stop interface execution if query failed |
Optional. If enabled, the system will stop any data manipulation if the query returns an error. |
Save Schema (enabled per interface) |
If selected, the schema is created for this step. |
Source Column |
Select the source column that contains numeric values. |
Target Column |
Select the target column where the absolute values of numbers will be inserted. |
- Click the Save button.